

/****** Object:  View [dbo].[vw_medianamik_generator_ObjectNames]    Script Date: 11/20/2008 14:02:57 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_medianamik_generator_ObjectNames]'))
DROP VIEW [dbo].[vw_medianamik_generator_ObjectNames]
GO


/****** Object:  View [dbo].[vw_medianamik_generator_PivotQuery]    Script Date: 11/20/2008 14:03:08 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_medianamik_generator_PivotQuery]'))
DROP VIEW [dbo].[vw_medianamik_generator_PivotQuery]
GO


/****** Object:  View [dbo].[vw_medianamik_generator_RelationNames]    Script Date: 11/20/2008 14:03:25 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_medianamik_generator_RelationNames]'))
DROP VIEW [dbo].[vw_medianamik_generator_RelationNames]
GO


/****** Object:  View [dbo].[vw_system_Group]    Script Date: 11/20/2008 14:04:18 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_Group]'))
DROP VIEW [dbo].[vw_system_Group]
GO


/****** Object:  View [dbo].[vw_system_Lock]    Script Date: 11/20/2008 14:04:49 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_Lock]'))
DROP VIEW [dbo].[vw_system_Lock]
GO


/****** Object:  View [dbo].[vw_system_Role]    Script Date: 11/20/2008 14:05:01 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_Role]'))
DROP VIEW [dbo].[vw_system_Role]
GO


/****** Object:  View [dbo].[vw_system_RolesInGroups]    Script Date: 11/20/2008 14:05:20 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_RolesInGroups]'))
DROP VIEW [dbo].[vw_system_RolesInGroups]
GO

/****** Object:  View [dbo].[vw_system_User]    Script Date: 11/20/2008 14:05:30 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_User]'))
DROP VIEW [dbo].[vw_system_User]
GO


/****** Object:  View [dbo].[vw_system_UsersInGroups]    Script Date: 11/20/2008 14:05:39 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_system_UsersInGroups]'))
DROP VIEW [dbo].[vw_system_UsersInGroups]
GO


/****** Object:  UserDefinedFunction [dbo].[fn_medianamik_generator_GetBaseColumns_old]    Script Date: 11/20/2008 14:06:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_medianamik_generator_GetBaseColumns_old]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fn_medianamik_generator_GetBaseColumns_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_UpdateGenRecordPosition_old]    Script Date: 11/20/2008 14:06:48 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_UpdateGenRecordPosition_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_UpdateGenRecordPosition_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_UpdateGenRecord_old]    Script Date: 11/20/2008 14:06:57 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_UpdateGenRecord_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_UpdateGenRecord_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_UpdateGenRecord_bkp2_old]    Script Date: 11/20/2008 14:07:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_UpdateGenRecord_bkp2_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_UpdateGenRecord_bkp2_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_UpdateGenRecord_bkp_old]    Script Date: 11/20/2008 14:08:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_UpdateGenRecord_bkp_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_UpdateGenRecord_bkp_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_GetOneToManyOptions_old]    Script Date: 11/20/2008 14:08:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_GetOneToManyOptions_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_GetOneToManyOptions_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_generator_RemoveColumn_old]    Script Date: 11/20/2008 14:08:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_RemoveColumn_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_RemoveColumn_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_generator_GetPivotedNodePropertyValues_old]    Script Date: 11/20/2008 14:08:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_GetPivotedNodePropertyValues_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_GetPivotedNodePropertyValues_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_generator_FillTable_old]    Script Date: 11/20/2008 14:09:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_FillTable_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_FillTable_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_generator_DropTable_old]    Script Date: 11/20/2008 14:09:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_DropTable_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_DropTable_old]
GO

/****** Object:  StoredProcedure [dbo].[medianamik_generator_CreateView_old]    Script Date: 11/20/2008 14:09:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_CreateView_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_CreateView_old]
GO

/****** Object:  StoredProcedure [dbo].[medianamik_generator_CreateTable_old]    Script Date: 11/20/2008 14:09:47 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_CreateTable_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_CreateTable_old]
GO

/****** Object:  StoredProcedure [dbo].[medianamik_generator_CheckGenTableExists_old]    Script Date: 11/20/2008 14:10:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_CheckGenTableExists_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_CheckGenTableExists_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_generator_AddColumn_old]    Script Date: 11/20/2008 14:10:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_generator_AddColumn_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_generator_AddColumn_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_DeleteGenRecord_old]    Script Date: 11/20/2008 14:10:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_DeleteGenRecord_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_DeleteGenRecord_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_dbo_UpdateGenTablesAndViewsRecursive_old]    Script Date: 11/20/2008 14:10:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_dbo_UpdateGenTablesAndViewsRecursive_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_dbo_UpdateGenTablesAndViewsRecursive_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_dbo_RemoveGenColumn_old]    Script Date: 11/20/2008 14:10:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_dbo_RemoveGenColumn_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_dbo_RemoveGenColumn_old]
GO

/****** Object:  StoredProcedure [dbo].[medianamik_dbo_DropGenTable_old]    Script Date: 11/20/2008 14:10:48 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_dbo_DropGenTable_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_dbo_DropGenTable_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_dbo_DropAllGenTables_old]    Script Date: 11/20/2008 14:10:54 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_dbo_DropAllGenTables_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_dbo_DropAllGenTables_old]
GO


/****** Object:  StoredProcedure [dbo].[medianamik_dbo_AddGenColumn_old]    Script Date: 11/20/2008 14:11:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[medianamik_dbo_AddGenColumn_old]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[medianamik_dbo_AddGenColumn_old]
GO



IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_TranslationResources_CreatedOn]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TranslationResources] DROP CONSTRAINT [DF_TranslationResources_CreatedOn]
END

GO


/****** Object:  Table [dbo].[TranslationResources]    Script Date: 11/20/2008 14:37:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TranslationResources]') AND type in (N'U'))
DROP TABLE [dbo].[TranslationResources]
GO



























